{"text_format":"3","workbook":"xlsx","n_sheets":25,"sheets":["Instructions","G8D Report - Change Date","Quality Notification","Sort Sheet","Minutes - Action Plan","D2 - Problem Statement Photo","D2 Problem Description","D2 Process Flow","D2 Cause & Effect","D3 - Verify & Validate","Deviation","D4 Root Cause 5 Why","D4 Comparative Analysis","D4 Root Cause Theories","D4 Test RC Theories","D5 Decision Making Worksheet 13","D5 Decision Making Worksheet 23","D5 Decision Making Workshee 33","PFMEA","Control Plan","Customer List","D0-D8 Assessing Questions","Data","Revision Log","Sheet2"],"not_rendered":{"images":13,"macros":1,"defined_names":3,"comments":17},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":28,"n_cols":1,"rows_kept":28,"merged":[[27,0,28,9]]}
["General Instructions & Reminders"]
[]
["1. Hover over the red triangles in the cells with the curser for either G8D or Excel hints."]
["2. Before updating the 8D, remember to copy the G8D report tab, and change the date."]
["3. Update the date in the upper right hand corner of the G8D form to match the tab date."]
["4. Remember to follow the D0-D8 Assessing Questions"]
["5. Use the tabs at the bottom of the worksheet as needed"]
["6. Change the worksheet tabs that are active yellow."]
["7. You can Hide the tabs that you aren't using at the bottom of the work sheet you aren't using."]
["8. Enable Macros by clicking the button above the formula bar before beginning work with the sheet"]
[]
[]
[]
[]
[]
[]
["9. You can use the buttons off to the side of the 8D report to switch between tabs"]
[]
[]
[]
[]
[]
["10.Clicking the 8D Report button will bring you back to the current version of the report you are working on"]
[]
[]
[]
[]
["11. All fields that are YELLOW are required to be filled in, don't worry, they will change to white after they have some information in them!"]

{"sheet":"G8D Report - Change Date","index":1,"n_rows":67,"n_cols":26,"rows_kept":67,"merged":[[0,1,0,6],[0,7,0,8],[0,9,0,10],[1,1,1,6],[1,7,1,8],[1,9,1,10],[2,1,2,6],[2,7,2,8],[2,9,2,10],[3,1,3,6],[3,7,3,8],[3,9,3,10],[4,1,4,4],[4,5,4,6],[4,7,4,8],[4,9,4,10],[5,1,5,4],[5,5,5,6],[5,7,5,8],[5,9,5,10],[6,0,6,6],[6,7,6,10],[7,1,7,6],[7,7,12,10],[8,1,8,6],[9,1,9,6],[10,1,10,6],[11,1,11,6],[12,1,12,6],[13,1,13,10],[14,0,14,6],[14,7,14,8],[14,9,14,10],[15,0,15,6],[15,7,15,8],[15,9,15,10],[16,0,16,8],[16,9,16,10],[17,0,17,1],[17,2,17,6],[17,7,17,8],[17,9,17,10],[17,12,17,15],[18,0,18,1],[18,2,18,6],[18,7,18,8],[18,9,18,10],[19,0,19,1],[19,2,19,6],[19,7,20,8],[19,9,20,10],[20,0,20,1],[20,2,20,6],[21,0,21,10],[22,0,22,10],[23,1,23,10],[24,1,24,10],[25,1,25,2],[25,3,25,6],[25,7,25,8],[25,9,25,10],[26,1,26,2],[26,3,26,6],[26,7,26,8],[26,9,26,10],[27,1,27,2],[27,3,27,6],[27,7,27,8],[27,9,27,10],[27,12,27,15],[28,1,28,2],[28,3,28,6],[28,7,28,8],[28,9,28,10],[29,1,29,2],[29,3,29,6],[29,7,29,8],[29,9,29,10],[30,1,30,2],[30,3,30,6],[30,7,30,8],[30,9,30,10],[31,1,31,2],[31,3,31,6],[31,7,31,8],[31,9,31,10],[32,1,32,2],[32,3,32,6],[32,7,32,8],[32,9,32,10],[33,0,33,1],[33,2,33,10],[34,0,34,1],[34,2,34,10],[35,0,35,6],[35,7,35,8],[35,9,35,10],[35,12,36,15],[36,0,36,6],[36,7,36,8],[36,9,36,10],[37,1,37,6],[37,7,37,8],[37,9,37,10],[38,1,38,10],[39,1,39,10],[40,0,40,1],[40,2,40,8],[40,9,40,10],[40,12,41,15],[41,0,41,8],[41,9,41,10],[42,1,42,10],[43,0,43,8],[43,9,43,10],[44,0,44,8],[44,9,44,10],[45,1,45,10],[45,12,46,15],[46,0,46,8],[46,9,46,10],[47,0,47,8],[47,9,47,10],[48,1,48,10],[48,12,49,15],[49,0,49,1],[49,2,49,6],[49,7,49,8],[49,9,49,10],[50,0,50,8],[50,9,50,10],[51,0,51,8],[51,9,51,10],[52,1,52,10],[52,12,53,15],[53,1,53,10],[54,0,54,8],[54,9,54,10],[55,0,55,8],[55,9,55,10],[56,0,56,8],[56,9,56,10],[57,0,57,8],[57,9,57,10],[58,0,58,8],[58,9,58,10],[59,0,59,8],[59,9,59,10],[60,0,60,8],[60,9,60,10],[61,0,61,6],[61,7,61,8],[61,9,61,10],[62,0,62,6],[62,7,62,8],[62,9,62,10],[63,0,63,1],[63,2,63,8],[63,9,63,10],[64,0,64,1],[64,2,64,8],[64,9,64,10],[65,0,65,1],[65,2,65,8],[65,9,65,10],[66,0,66,10],[67,0,67,10]]}
["G8D Number:",{"$nulls":6},"Received By",null,"Last Updated"]
["Title:"]
["Customer:",{"$nulls":6},"Date Open",null,"Date Responded"]
["Customer #"]
["Customer Contact","email",{"$nulls":3},"Phone",null,"Time (am/pm)",null,"Time (am/pm)"]
[]
["PRODUCT / PROCESS INFORMATION ",{"$nulls":6},"Organizational Information"]
["Customer Part Name & Number",{"$nulls":24},{"$f":"B8","v":0}]
["P&S 8-digit #",{"$nulls":24},0]
["Part Description",{"$nulls":24},0]
["Lot Control #",{"$nulls":24},0]
["Work Center #",{"$nulls":24},0]
["Quantity of Parts:",{"$nulls":24},0]
["DØ SYMPTOM(S)",{"$nulls":24},0]
["DØ EMERGENCY RESPONSE ACTION(S)",{"$nulls":6},"% Effective",null,"Implemented"]
[{"$nulls":25},{"$f":"A16","v":0}]
["Quality Notification Posted and a copy placed on the Quality Notification Tab?"]
["Deviation Needed?",{"$nulls":6},"Deviation #:",null,{"$f":"IF(C18=\"Yes\",0,1)","v":1}]
["Quantity of Parts Returned:",{"$nulls":6},"Hold Tag #:"]
["Date Parts Returned:",{"$nulls":6},"(NCM CODE LIST)"]
["Return Authorization #"]
["Returned Parts Analysis - Specific dimension or feature that is out of tolerance or defective:"]
[{"$nulls":25},{"$f":"A23","v":0}]
["Verification:",{"$nulls":24},{"$f":"B24","v":0}]
["Validation:",{"$nulls":24},{"$f":"B25","v":0}]
["D1 TEAM ","Name",null,"email",{"$nulls":3},"Department",null,"Phone"]
["Champion:"]
["Team Leader:"]
["Team Member:"]
["Team Member:"]
["Team Member:"]
["Team Member:"]
["Facilitator:"]
["D2 PROBLEM STATEMENT",null,"PROBLEM DESCRIPTION"]
[{"$nulls":25},{"$f":"A35 & C35","v":""}]
["D3 INTERIM CONTAINMENT ACTION(S)",{"$nulls":6},"% Effective",null,"Implemented"]
[{"$nulls":25},{"$f":"A37","v":0}]
["Deviation Needed?",{"$nulls":6},"Deviation #",null,{"$f":"IF(B38=\"Yes\",0,1)","v":1}]
["Verification:",{"$nulls":24},{"$f":"B39","v":0}]
["Validation:",{"$nulls":24},{"$f":"B40","v":0}]
["D4 ROOT CAUSE(S)",null,"Use (5 Why Analysis) or (IS / IS NOT)",{"$nulls":6},"% Contribution"]
[{"$nulls":25},{"$f":"A42","v":0}]
["Verification:",{"$nulls":24},{"$f":"B43","v":0}]
["D5 CHOSEN PERMANENT CORRECTIVE ACTION(S)",{"$nulls":8},"% Effective"]
[{"$nulls":25},{"$f":"A45","v":0}]
["Verification:",{"$nulls":24},{"$f":"B46","v":0}]
["D6 IMPLEMENT PERMANENT CORRECTIVE ACTION(S)",{"$nulls":8},"Implemented"]
[{"$nulls":25},{"$f":"A48","v":0}]
["Validation:",{"$nulls":24},{"$f":"B49","v":0}]
["Change Request Needed?",{"$nulls":6},"CR Number:",null,{"$f":"IF(C50=\"Yes\",0,1)","v":1}]
["D7 PREVENT ACTIONS",{"$nulls":8},"Implemented"]
[{"$nulls":25},{"$f":"A52","v":0}]
["Verification:",{"$nulls":24},{"$f":"B53","v":0}]
["Validation:",{"$nulls":24},{"$f":"B54","v":0}]
["PFMEA Reviewed and Updated and a copy place on the PFMEA Tab?"]
["Control Plan Reviewed and Updated and a copy placed on the Control Plan Tab?"]
["All relevant documents updated?"]
["Sort/Rework Repair Sheet Scanned and placed in Sort Sheet Tab?"]
["Monitor in Layered Process Auditing?"]
["D7 SYSTEMIC PREVENT RECOMMENDATIONS",{"$nulls":8},"Responsibility"]
[{"$nulls":25},{"$f":"A61","v":0}]
["D8 TEAM AND INDIVIDUAL RECOGNITION",{"$nulls":6},"Reported By",null,"Date Close"]
[{"$nulls":25},{"$f":"A63","v":0}]
["Approval",null,"Signature",{"$nulls":6},"Date"]
["Customer (If Required):"]
["QC Manager:"]
["Additional Information:"]

{"sheet":"Quality Notification","index":2,"n_rows":2,"n_cols":1,"rows_kept":2}
["Evidence of Quality Notification"]
["If no Quality Notification is required, please explain why not below, and show evidence if possible:"]

{"sheet":"Sort Sheet","index":3,"n_rows":2,"n_cols":1,"rows_kept":2}
["Evidence of Sort/Rework/Repair Sheet"]
["If no sort is required, please explain why not below, and show evidence if possible:"]

{"sheet":"Minutes - Action Plan","index":4,"n_rows":22,"n_cols":5,"rows_kept":22}
[]
[null,"Meeting Minutes"]
["Date","Notes"]
{"$rows_empty":7}
[null,"Action Plan"]
["Item","Task Description","Responsible","Due","Completed Date"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]

{"sheet":"D2 - Problem Statement Photo","index":5,"n_rows":31,"n_cols":1,"rows_kept":31,"merged":[[3,0,26,9],[30,0,53,9]]}
["Problem Statement Photo Evidence"]
["Part Description:"]
["Part Number:"]
["Photograph(s) of Part"]
{"$rows_empty":25}
["Defect Description:"]
["Photograph(s) of Defect"]

{"sheet":"D2 Problem Description","index":6,"n_rows":9,"n_cols":9,"rows_kept":9,"hidden":true,"merged":[[0,0,0,10],[1,0,1,2],[1,3,1,10],[2,0,2,10],[3,0,3,1],[3,2,3,4],[3,5,3,7],[3,8,3,10],[4,0,5,0],[4,2,4,4],[4,5,4,7],[4,8,4,10],[5,2,5,4],[5,5,5,7],[5,8,5,10],[6,2,6,4],[6,5,6,7],[6,8,6,10],[7,2,7,4],[7,5,7,7],[7,8,7,10],[8,2,8,4],[8,5,8,7],[8,8,8,10]]}
["Problem Solving Worksheet\nProblem Description"]
["Problem Statement: ",null,null,{"$f":"'G8D Report - Change Date'!A35","v":0}]
["(What is wrong with what?)"]
["Problem Description",null,"IS",null,null,"IS NOT",null,null,"Get Information"]
["WHAT",1,"Object\n"]
[null,2,"Defect\n"]
["WHERE",3]
["WHEN",null,"First Seen\n"]
["HOW BIG"]

{"sheet":"D2 Process Flow","index":7,"n_rows":3,"n_cols":1,"rows_kept":3,"hidden":true}
["Process Flow"]
[]
["(View hidden note with Red triangle above for instructions)"]

{"sheet":"D2 Cause & Effect","index":8,"n_rows":1,"n_cols":5,"rows_kept":1,"hidden":true}
[{"$nulls":4},"Cause and Effect Diagram"]

{"sheet":"D3 - Verify & Validate","index":9,"n_rows":28,"n_cols":1,"rows_kept":28,"hidden":true,"merged":[[2,0,24,9],[28,0,50,9]]}
["Interim Containment Action"]
["Verification Evidence - Before Implementing ICA"]
{"$rows_empty":25}
["Validation Evidence - After Implementing ICA"]

{"sheet":"Deviation","index":10,"n_rows":1,"n_cols":1,"rows_kept":1,"hidden":true}
["Evidence of Deviation"]

{"sheet":"D4 Root Cause 5 Why","index":11,"n_rows":1,"n_cols":1,"rows_kept":1,"merged":[[6,0,6,8],[7,0,7,8],[8,0,8,8],[9,0,9,8],[10,0,10,8],[15,0,15,8],[16,0,16,8],[17,0,17,8],[18,0,18,8],[19,0,19,8]]}
["Root Cause Analysis - 3 Legged 5 Why"]

{"sheet":"D4 Comparative Analysis","index":12,"n_rows":7,"n_cols":5,"rows_kept":7,"hidden":true,"merged":[[0,0,0,4],[1,0,1,1],[2,0,3,0]]}
["Problem Solving Worksheet\nComparative Analysis"]
["Problem\nDescription",null,"Differences","Changes","Dates"]
["WHAT",1,"Object:\n"]
[null,2,"Defect:"]
["WHERE",3]
["WHEN"]
["HOW BIG"]

{"sheet":"D4 Root Cause Theories","index":13,"n_rows":8,"n_cols":1,"rows_kept":8,"hidden":true}
["Problem Solving Worksheet\nRoot Cause Theories"]
["a."]
["b."]
["c."]
["d."]
["e."]
["f."]
["g."]

{"sheet":"D4 Test RC Theories","index":14,"n_rows":10,"n_cols":8,"rows_kept":10,"hidden":true,"merged":[[0,2,0,7],[1,0,4,1],[1,2,1,7],[2,2,2,3],[2,4,2,5],[2,6,2,7],[3,2,3,3],[3,4,3,5],[3,6,3,7],[5,0,6,0]]}
[null,null,"Problem Solving Worksheet\nTrial Run of Root Cause Theories"]
["Problem\nDescription",null,"Test For Most Likely Causes (+) (-) (?)"]
[null,null,"a. Type Root Cause Theory here",null,"c. Type Root Cause Theory here",null,"e. Type Root Cause Theory here"]
[null,null,"b. Type Root Cause Theory here",null,"d. Type Root Cause Theory here",null,"f. Type Root Cause Theory here"]
[null,null,"a.","b.","c.","d.","e.","f."]
["WHAT",1]
[null,2]
["WHERE","3\n\n\n\n\n\n\n\n\n","\n\n\n\n\n\n\n\n\n\n","\n\n\n\n\n\n\n\n\n","\n\n\n\n\n\n\n\n\n","\n\n\n\n\n\n\n\n\n","\n\n\n\n\n\n\n\n\n","\n\n\n\n\n\n\n\n\n"]
["WHEN","\n\n\n\n\n"]
["HOW BIG","\n\n\n\n\n\n\n\n"]

{"sheet":"D5 Decision Making Worksheet 13","index":15,"n_rows":20,"n_cols":2,"rows_kept":20,"hidden":true,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1]]}
["DECISION MAKING WORKSHEET\nChosen Permanent Corrective Actions"]
["①  END RESULT:  "]
["② CRITERIA"]
["GIVENS: (Mandatory, Measurable, Realistic)"]
["a."]
["b."]
["c."]
["d."]
["e."]
["WANTS: (Objective or Subjective)","③\nHOW IMPORTANT\n(1-10)"]
["a."]
["b."]
["c."]
["d."]
["e."]
["f."]
["g."]
["h."]
["i."]
["j."]

{"sheet":"D5 Decision Making Worksheet 23","index":16,"n_rows":21,"n_cols":6,"rows_kept":21,"hidden":true,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,2],[2,3,2,5],[3,0,3,1],[3,3,3,4],[4,0,4,1],[4,3,4,4],[5,0,5,1],[5,3,5,4],[6,0,6,1],[6,3,6,4],[7,0,7,1],[7,3,7,4],[8,0,8,1],[8,3,8,4]]}
["DECISION MAKING WORKSHEET\nChosen Permanent Corrective Actions"]
["④  CHOICES AVAILABLE - (INNOVATE)  "]
["A.",null,null,"B."]
["GIVENS INFORMATION:⑤",null,"Y/N","GIVENS INFORMATION:⑤",null,"Y/N"]
["a.",null,null,"a."]
["b.",null,null,"b."]
["c.",null,null,"c."]
["d.",null,null,"d."]
["e.",null,null,"e."]
["WANTS INFORMATION:","⑤\nHOW GOOD\n(0-10)","SCORE","WANTS INFORMATION:","⑤\nHOW GOOD\n(0-10)","SCORE"]
["a.",null,{"$f":"B11*'D5 Decision Making Worksheet 23'!B11","v":0},"a.",null,{"$f":"E11*'D5 Decision Making Worksheet 13'!B11","v":0}]
["b.",null,{"$f":"B12*'D5 Decision Making Worksheet 13'!B12","v":0},"b.",null,{"$f":"E12*'D5 Decision Making Worksheet 13'!B12","v":0}]
["c.",null,{"$f":"B13*'D5 Decision Making Worksheet 13'!B13","v":0},"c.",null,{"$f":"E13*'D5 Decision Making Worksheet 13'!B13","v":0}]
["d.",null,{"$f":"B14*'D5 Decision Making Worksheet 13'!B14","v":0},"d.",null,{"$f":"E14*'D5 Decision Making Worksheet 13'!B14","v":0}]
["e.",null,{"$f":"B15*'D5 Decision Making Worksheet 23'!B15","v":0},"e.",null,{"$f":"E15*'D5 Decision Making Worksheet 13'!B15","v":0}]
["f.",null,{"$f":"B16*'D5 Decision Making Worksheet 13'!B16","v":0},"f.",null,{"$f":"E16*'D5 Decision Making Worksheet 13'!B16","v":0}]
["g.",null,{"$f":"B17*'D5 Decision Making Worksheet 23'!B17","v":0},"g.",null,{"$f":"E17*'D5 Decision Making Worksheet 13'!B17","v":0}]
["h.",null,{"$f":"B18*'D5 Decision Making Worksheet 13'!B18","v":0},"h.",null,{"$f":"E18*'D5 Decision Making Worksheet 13'!B18","v":0}]
["i.",null,{"$f":"B19*'D5 Decision Making Worksheet 23'!B19","v":0},"i.",null,{"$f":"E19*'D5 Decision Making Worksheet 13'!B19","v":0}]
["j.",null,{"$f":"B20*'D5 Decision Making Worksheet 13'!B20","v":0},"j.",null,{"$f":"E20*'D5 Decision Making Worksheet 13'!B20","v":0}]
["RELATIVE MERIT\n(Total Score)",null,{"$f":"SUM(C11:C20)","v":0},"RELATIVE MERIT\n(Total Score)",null,{"$f":"SUM(F11:F20)","v":0}]

{"sheet":"D5 Decision Making Workshee 33","index":17,"n_rows":8,"n_cols":4,"rows_kept":8,"hidden":true,"merged":[[0,0,0,3],[1,0,1,3],[2,1,2,3]]}
["DECISION MAKING WORKSHEET\nChosen Permanent Corrective Actions"]
["⑥  RISK ANALYSIS:\n(IF WE DO THIS, WHAT MIGHT HAPPEN CONTRARY TO OUR INTEREST?)  "]
["SOURCES","⑦ATTRACTIVE CHOICES"]
["(CHOICE)",null,"P","S"]
["1. RISK What characteristics of this choice may fail to satisfy totally the GIVENS?"]
["2. RISK What features or characteristics of this CHOICE comprise or threaten an important WANT?"]
["3. UNIVERSAL\nDo you anticipate problems with this choice in any of the following categories?\nPeople\nOrganization\nExternal Influences\nFacilities\nEquipment\nIdeas - Polices - Processes\nMaterials\nMoney - Economics\nCapacity\nQuality\nTiming\nPersonal Interferences\n\n\n"]
["Procedure: Investigate one choice at a time. All threat assessment by the same individual or group.  Apply \"If…then\" format.\n\nEstimate likelihood of occurrence (Probability 1-10)\n10 = Definitely will happen\n1 =  Highly unlikely to happen\n\nState consequences if it does occur (Severity 1-10)\n10 = Extremely critical\n1 = Little consequence\n\nList each consequence individually and evaluate the seriousness of each consequence individually."]

{"sheet":"PFMEA","index":18,"n_rows":2,"n_cols":1,"rows_kept":2}
["Evidence of PFMEA update"]
["If no update is required, please explain why not below, and show evidence if possible:"]

{"sheet":"Control Plan","index":19,"n_rows":2,"n_cols":1,"rows_kept":2}
["Evidence of Control Plan Update"]
["If no update is required, please explain why not below, and show evidence if possible:"]

{"sheet":"Customer List","index":20,"n_rows":14,"n_cols":2,"rows_kept":14,"hidden":true}
[1]
[1,"Auto Car LLC"]
[null,"Chrysler (OEM & SERVICE) 72491"]
[null,"Ford (OEM & Service) P622D"]
[null,"Freightliner Corporation T896 MFG"]
[null,"IC Corporation 65841X1"]
[null,"OMMC 72491"]
[null,"Navistar (65841 - AX) 6584160"]
[null,"Tomen Corporation/NSK PANDS"]
[null,"Torque Traction Int Tech Inc. 0000019520"]
[null,"Volvo GM Heavy Truck 63051"]
[null,"Volvo Heavey Truck/AFTMKT 63051"]
[null,"Workhorse Custom Chassis 00600971"]
[null,"ZF Heavy Duty Steering 3110"]

{"sheet":"D0-D8 Assessing Questions","index":21,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}

{"sheet":"Data","index":22,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Revision Log","index":23,"n_rows":3,"n_cols":4,"rows_kept":3}
[]
[null,"Revision","Changes","By"]
[null,"E","Added Quality Notification Tab, Sort Sheet Tab. Cleaned up formatting issues, added tracking questions for new tabs.  Hid unused tabs, fixed issue with auto-adjusting row heights.  Merged Meeting Minutes and Action Plan tabs","JJH"]

{"sheet":"Sheet2","index":24,"n_rows":20,"n_cols":1,"rows_kept":20,"merged":[[10,0,10,9],[19,0,19,9]]}
{"$rows_empty":10}
["Click the button below to take you back to the INSTRUCTIONS"]
{"$rows_empty":8}
["Click the button below to take you to the 8D report"]